﻿BEGIN TRAN

USE [Product]  /* change to your project DB */

declare @id int

-- Content Type
INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('application/excel', 'MS Excel', '.xls', 0, 1)
INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('application/msword', 'MS Word', '.doc', 1, 2)
INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('text/plain', 'Text plain', '.txt', 0, 3)
INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('text/xml', 'XML document', '.xml', 0, 4)
INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('application/pdf', 'PDF document', '.pdf', 1, 5)

INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('image/gif', 'Image gif', '.gif', 1, 6)
INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('image/png', 'Image png', '.png', 1, 7)
INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('image/jpg', 'Image jpg', '.jpg', 1, 8)
INSERT INTO [dbo].[CodeListContentType] ([Code] ,[Name], [Suffix], [IsVisible], [ContentTypeId])
     VALUES ('application/zip', 'Zipped file', '.zip', 1, 9)


/* ArticleGroup ArticleCategory */
INSERT INTO [dbo].[CodeListTiny] ([Code] ,[Name], [IsVisible], [CodeListTinyId], [Discriminator])
     VALUES ('Any', 'Any', 1, 1, 'ArticleCategory')
INSERT INTO [dbo].[CodeListTiny] ([Code] ,[Name], [IsVisible], [CodeListTinyId], [Discriminator])
     VALUES ('Documentation', 'Documentation', 1, 2, 'ArticleCategory')
INSERT INTO [dbo].[CodeListTiny] ([Code] ,[Name], [IsVisible], [CodeListTinyId], [Discriminator])
     VALUES ('Any', 'Any', 1, 3, 'ArticleGroup')
INSERT INTO [dbo].[CodeListTiny] ([Code] ,[Name], [IsVisible], [CodeListTinyId], [Discriminator])
     VALUES ('Basic', 'Basic', 1, 4, 'ArticleGroup')

--ROLLBACK TRAN
COMMIT TRAN